// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_MST_PERSON
// * CreateDate    : 2011/11/16 10:36:34
// * Creater       : CodeSmith
// * LastChangeDate: 2011/11/16 10:36:34
// * LastChanger   : 2011/11/16 10:36:34
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class MstPersonTable : TableInfo
    {
		public const string C_TableName = "MST_PERSON";
		
		public const string C_PERSON_ID = "PERSON_ID";
		public const string C_DEPARTMENT_ID = "DEPARTMENT_ID";
		public const string C_POSITION_ID = "POSITION_ID";
		public const string C_SUPERVISOR = "SUPERVISOR";
		public const string C_PERSON_CODE = "PERSON_CODE";
		public const string C_NAME_CN = "NAME_CN";
		public const string C_NAME_EN = "NAME_EN";
		public const string C_GENDER = "GENDER";
		public const string C_BIRTHDAY = "BIRTHDAY";
		public const string C_COUNTRY = "COUNTRY";
		public const string C_PROVINCE = "PROVINCE";
		public const string C_CITY = "CITY";
		public const string C_ADDRESS = "ADDRESS";
		public const string C_EMAIL = "EMAIL";
		public const string C_MOBILE = "MOBILE";
		public const string C_TELEPHONE = "TELEPHONE";
		public const string C_STATUS = "STATUS";
		public const string C_ADVANCE_AMOUNT = "ADVANCE_AMOUNT";
		public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
		public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
        public const string C_ATTACHMENT = "ATTACHMENT";
		
		public MstPersonTable()
        {
            _tableName = "MST_PERSON";
        }
		
		protected static MstPersonTable _current;
        public static MstPersonTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new MstPersonTable();

            _current.Add(C_PERSON_ID, new ColumnInfo(C_PERSON_ID,"PersonId", true, typeof(string)));
            _current.Add(C_DEPARTMENT_ID, new ColumnInfo(C_DEPARTMENT_ID,"DepartmentId", false, typeof(string)));
            _current.Add(C_POSITION_ID, new ColumnInfo(C_POSITION_ID,"PositionId", false, typeof(string)));
            _current.Add(C_SUPERVISOR, new ColumnInfo(C_SUPERVISOR,"Supervisor", false, typeof(string)));
            _current.Add(C_PERSON_CODE, new ColumnInfo(C_PERSON_CODE,"PersonCode", false, typeof(string)));
            _current.Add(C_NAME_CN, new ColumnInfo(C_NAME_CN,"NameCn", false, typeof(string)));
            _current.Add(C_NAME_EN, new ColumnInfo(C_NAME_EN,"NameEn", false, typeof(string)));
            _current.Add(C_GENDER, new ColumnInfo(C_GENDER,"Gender", false, typeof(string)));
            _current.Add(C_BIRTHDAY, new ColumnInfo(C_BIRTHDAY,"Birthday", false, typeof(string)));
            _current.Add(C_COUNTRY, new ColumnInfo(C_COUNTRY,"Country", false, typeof(string)));
            _current.Add(C_PROVINCE, new ColumnInfo(C_PROVINCE,"Province", false, typeof(string)));
            _current.Add(C_CITY, new ColumnInfo(C_CITY,"City", false, typeof(string)));
            _current.Add(C_ADDRESS, new ColumnInfo(C_ADDRESS,"Address", false, typeof(string)));
            _current.Add(C_EMAIL, new ColumnInfo(C_EMAIL,"Email", false, typeof(string)));
            _current.Add(C_MOBILE, new ColumnInfo(C_MOBILE,"Mobile", false, typeof(string)));
            _current.Add(C_TELEPHONE, new ColumnInfo(C_TELEPHONE,"Telephone", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
            _current.Add(C_ADVANCE_AMOUNT, new ColumnInfo(C_ADVANCE_AMOUNT,"AdvanceAmount", false, typeof(decimal)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE,"LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY,"LastModifiedBy", false, typeof(string)));
            _current.Add(C_ATTACHMENT, new ColumnInfo(C_ATTACHMENT, "Attachment", false, typeof(string)));
		}
		
		public ColumnInfo PERSON_ID
        {
            get { return this[C_PERSON_ID]; }
        }
		
		public ColumnInfo DEPARTMENT_ID
        {
            get { return this[C_DEPARTMENT_ID]; }
        }
		
		public ColumnInfo POSITION_ID
        {
            get { return this[C_POSITION_ID]; }
        }
		
		public ColumnInfo SUPERVISOR
        {
            get { return this[C_SUPERVISOR]; }
        }
		
		public ColumnInfo PERSON_CODE
        {
            get { return this[C_PERSON_CODE]; }
        }
		
		public ColumnInfo NAME_CN
        {
            get { return this[C_NAME_CN]; }
        }
		
		public ColumnInfo NAME_EN
        {
            get { return this[C_NAME_EN]; }
        }
		
		public ColumnInfo GENDER
        {
            get { return this[C_GENDER]; }
        }
		
		public ColumnInfo BIRTHDAY
        {
            get { return this[C_BIRTHDAY]; }
        }
		
		public ColumnInfo COUNTRY
        {
            get { return this[C_COUNTRY]; }
        }
		
		public ColumnInfo PROVINCE
        {
            get { return this[C_PROVINCE]; }
        }
		
		public ColumnInfo CITY
        {
            get { return this[C_CITY]; }
        }
		
		public ColumnInfo ADDRESS
        {
            get { return this[C_ADDRESS]; }
        }
		
		public ColumnInfo EMAIL
        {
            get { return this[C_EMAIL]; }
        }
		
		public ColumnInfo MOBILE
        {
            get { return this[C_MOBILE]; }
        }
		
		public ColumnInfo TELEPHONE
        {
            get { return this[C_TELEPHONE]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		public ColumnInfo ADVANCE_AMOUNT
        {
            get { return this[C_ADVANCE_AMOUNT]; }
        }
		
		public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }
		
		public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }

        public ColumnInfo ATTACHMENT
        {
            get { return this[C_ATTACHMENT]; }
        }
		
	}
}

